IBDAC

TIBCSQL Properties

Properties of the TIBCSQL class.

For a complete list of the TIBCSQL class members, see the TIBCSQL Members topic.

Public

Name Description

ChangeCursor (inherited from TCustomDASQL)

 Enables or disables changing screen cursor when executing commands in the NonBlocking mode.

Debug (inherited from TCustomDASQL)

 Used to display the statement that is being executed and the values and types of its parameters.

ExplainPlan

 Used to obtain the query execution plan for Table, Query, and SQL components.

FinalSQL (inherited from TCustomDASQL)

 Used to return a SQL statement with expanded macros.

Handle

 Used to specify the handle for the SQL statement of TIBCSQL.

MacroCount (inherited from TCustomDASQL)

 Used to get the number of macros associated with the Macros property.

Macros (inherited from TCustomDASQL)

 Makes it possible to change SQL queries easily.

ParamCheck (inherited from TCustomDASQL)

 Used to specify whether parameters for the Params property are implicitly generated when the SQL property is being changed.

ParamCount (inherited from TCustomDASQL)

 Indicates the number of parameters in the Params property.

ParamValues (inherited from TCustomDASQL)

 Used to get or set the values of individual field parameters that are identified by name.

Plan

 Used to get or set the PLAN clause of the SELECT statement.

Prepared (inherited from TCustomDASQL)

 Used to indicate whether a query is prepared for execution.

RowsAffected (inherited from TCustomDASQL)

 Used to indicate the number of rows which were inserted, updated, or deleted during the last query operation.

SQL (inherited from TCustomDASQL)

 Used to provide a SQL statement that a TCustomDASQL component executes when the Execute method is called.

SQLType

 Used to provide the typecode of the SQL statement being processed by the InterBase server.

Published

Name Description

Connection

 Used to set or return the connection associated with the query.

DescribeParams

 Used to specify whether to query TIBCParam properties from the server when executing the TCustomDASQL.Prepare method.

Params

 Contains the parameters for SQL statement.

Transaction

 Used to set or return the transaction to be used by the component.

See Also

© 1997-2024 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback